<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Calculating totals in documents</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ol.whs1 { list-style:decimal; }
ul.whs2 { list-style:disc; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying documents and dashboards\nCreating and formatting a document\nWorking with metrics and totals in documents\nCalculating totals and summary metrics in documents\nCalculating totals in documents");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Calculating totals in documents </h1>
<p>Totals reflect accumulations at selected levels and can be applied to 
 any document. A metric is calculated differently depending on its location 
 in the document; for specifics, see 
<a HREF="Totals_and_summary_metrics.htm">Calculating 
 totals and summary metrics in documents</a>.</p>
<p>A total uses the default subtotal function as set in the metric definition. 
 To specify the function used to calculate a subtotal, create a summary 
 metric. </p>
<h2>To calculate a total</h2>
<ol type="1" class="whs1">
	
<li class=p><p>Open the document in <span style="font-weight: bold;"><B>Design 
 Mode</B></span> or <span style="font-weight: bold;"><B>Editable Mode</B></span>. 
 </p></li>
	
<li class=p><p>In the document layout area, right-click the metric 
 to be totaled and select <span style="font-weight: bold;"><B>Copy</B></span>.</p></li>
	
<li class=p><p>Right-click in the position to place the metric and 
 select <span style="font-weight: bold;"><B>Paste</B></span>. </p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p>If you copy 
 the metric to a grouping header/footer, the metric will be subtotaled 
 at that level.</p></li>
		
<li style="list-style: disc;" type=disc class=p><p>If you copy 
 the metric to the Page Header/Footer or the Document Header/Footer, a 
 grand total for the metric will be calculated.</p></li>
	</ul>
</ol>
<p><span style="font-weight: bold;"><B>Note</B></span>: Copying the metric from 
 the Layout area also copies the metric's formatting. If you drag the metric 
 from Dataset Objects, the 
<a HREF="Control_defaults.htm">control default</a> 
 formatting is used. </p>
<h3>Related topics</h3>
<ul type="disc" class="whs2">
	
<li class=p><p>
<a HREF="Creating_summary_metrics_documents.htm">Creating 
 summary metrics in documents</a></p></li>
	
<li class=p><p>
<a HREF="Add_data_fields_to_document.htm">Adding data 
 fields to a document</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
